{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["M","B","I","D","D1"],"not_rendered":{"images":2,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"M","index":0,"n_rows":20,"n_cols":10,"rows_kept":20}
{"$rows_empty":16}
[{"$nulls":3},"A","Financiële kengetallen",{"$nulls":4},"             klik =>"]
[]
[]
[{"$nulls":3},"B","Activiteiten kengetallen",{"$nulls":4},"             klik =>"]

{"sheet":"B","index":1,"n_rows":29,"n_cols":13,"rows_kept":29}
[]
[{"$nulls":3},"          Balansen",{"$nulls":4},"Kengetallen?",null,2006,null,2007]
[null,"Activa","31-12-06","31-12-07","Passiva","31-12-06","31-12-07"]
[null,"Gebouwen",3000,10000,"EV",4000,4200,null,"Liquiditeit"]
[null,"Voorraden",1500,2000,"Hypotheek",1500,4500,null,"Current Ratio",null,2.14]
[null,"Debiteuren",3000,2800,"Bank",1000,3800,null,"Quick Ratio",null,1.45]
[null,"Kas",200,200,"Crediteuren",1200,2500]
[null,null,{"$f":"SUM(C4:C7)","v":7700},{"$f":"SUM(D4:D7)","v":15000},null,{"$f":"SUM(F4:F7)","v":7700},{"$f":"SUM(G4:G7)","v":15000},null,"Solvabiliteit"]
[{"$nulls":8},"Solvabiliteitspercentage",null,52,{"$f":"IF(K9=\"\",\"\",IF(K9=52,\"%\",\"\"))","v":"%"}]
[null,"         Resultatenrekening 2006",null,null,"        Resultatenrekening 2007"]
[null,null,"Kosten","Opbrengsten",null,"Kosten","Opbrengsten",null,"Rentabiliteit"]
[null,"Opbrengsten",null,14600,"Opbrengsten",null,16000,null,"RTV",null,34,{"$f":"IF(K12=\"\",\"\",IF(K12=34,\"%\",\"\"))","v":"%"}]
[null,"Inkoop",6200,null,"Inkoop",7000,null,null,"REV",null,55,{"$f":"IF(K13=\"\",\"\",IF(K13=55,\"%\",\"\"))","v":"%"}]
[null,"Bedr.kosten",5000,null,"Bedr. kosten",6200,null,null,"RVV",null,11,{"$f":"IF(K14=\"\",\"\",IF(K14=11,\"%\",\"\"))","v":"%"}]
[null,"Afschrijving",800,null,"Afschrijving",1400,null,null,"Hefboomeffect",null,21,{"$f":"IF(K15=\"\",\"\",IF(K15=21,\"%\",\"\"))","v":"%"}]
[null,"Rente",400,null,"Rente",1000]
[null,"Winst 2006",{"$f":"14600-SUM(C13:C16)","v":2200},null,"Winst 2007",400]
[null,null,14600,{"$f":"D12-D17","v":14600},null,{"$f":"SUM(F13:F17)","v":16000},{"$f":"G12-G17","v":16000}]
[]
[]
[null,null,"Het hefboomeffect in 2006"]
[]
[null,null," ''Groen Advies'' heeft geld geleend tegen 11%"]
[null,null,"het eigen bedrijf heeft een rendement van 34%. "]
[null,null,"Elke geleende euro laat de opbrengst van het"]
[null,null,"eigen vermogen stijgen tot (ver) boven de RTV."]
[]
[null,null,"Reken uit hoe groot het verschil tussen REV en"]
[null,null,"RTV bij -Groen Advies- is."]

{"sheet":"I","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"D","index":3,"n_rows":32,"n_cols":12,"rows_kept":32}
[]
[null,"           Balans"]
["Activa","31-12-06","Passiva","31-12-06",{"$nulls":5},6200,6200,"Inkoopkosten"]
["Gebouwen",3000,"EV",4000,{"$nulls":3},"O"]
["Voorraden",1500,"Hypotheek",1500,{"$nulls":3},"Omzet"]
["Debiteuren",3000,"Bank",1000,null,"TR",null,"(euro's)",null,5000,5000,"Bedrijfskosten"]
["Kas",200,"Crediteuren",1200,null,"Totaal",null,14600]
[null,{"$f":"SUM(B4:B7)","v":7700},null,{"$f":"SUM(D4:D7)","v":7700},null,"Resultaat"]
[{"$nulls":5},2600,null,12000,null,800,800,"Afschrijvingen"]
[{"$nulls":3},"100 x TR / O",{"$nulls":3},"Totale"]
[{"$nulls":3},"Bruto",{"$nulls":3},"kosten"]
[{"$nulls":3},"marge",null,"Omzet",null,"TK"]
[{"$nulls":3},17.8,null,"(euro's)"]
[{"$nulls":5},14600]
[null,"RTV",{"$nulls":3},"O"]
["TR / TV"]
[null,"%",{"$nulls":3},"O"]
[]
[{"$nulls":5},"(euro's)"]
[{"$nulls":5},"Omzet"]
[{"$nulls":3},"Omloop-",{"$nulls":3},"Vl.A"]
[{"$nulls":3},"snelheid",{"$nulls":3},"Vlottende",null,1500,1500,"Voorraden"]
[{"$nulls":3},"O / TV",{"$nulls":3},"Activa"]
[{"$nulls":5},"Totaal"]
["Resultatenrekening 2006",null,"Kosten","Opbrengsten",null,"Vermogen",{"$nulls":3},3000,3000,"Debiteuren"]
["Opbrengsten",null,null,14600,null,"TV"]
["Inkoopkosten",null,6200,{"$nulls":4},"Vaste"]
["Bedrijfskosten",null,5000,{"$nulls":4},"Activa",null,200,200,"Kas"]
["Afschrijving",null,800,{"$nulls":4},"VA"]
["Rente",null,400]
["Winst 2006",null,{"$f":"14600-SUM(C27:C30)","v":2200}]
["Totaal",null,14600,{"$f":"D26-D31","v":14600}]

{"sheet":"D1","index":4,"n_rows":32,"n_cols":12,"rows_kept":32}
[]
[null,"           Balans"]
["Activa","31-12-06","Passiva","31-12-06",{"$nulls":5},6200,6200,"Inkoopkosten"]
["Gebouwen",3000,"EV",4000,{"$nulls":3},"O"]
["Voorraden",1500,"Hypotheek",1500,{"$nulls":3},"Omzet"]
["Debiteuren",3000,"Bank",1000,null,"TR",null,"(euro's)",null,5000,5000,"Bedrijfskosten"]
["Kas",200,"Crediteuren",1200,null,"Totaal",null,14600]
[null,{"$f":"SUM(B4:B7)","v":7700},null,{"$f":"SUM(D4:D7)","v":7700},null,"Resultaat"]
[{"$nulls":5},{"$f":"14600-H9","v":2600},null,{"$f":"J3+J6+J9+J12","v":12000},null,800,800,"Afschrijvingen"]
[{"$nulls":3},"100 x TR / O",{"$nulls":3},"Totale"]
[{"$nulls":3},"Bruto",{"$nulls":3},"Kosten"]
[{"$nulls":3},"marge",null,"Omzet",null,"TK"]
[{"$nulls":3},{"$f":"100*F9/F14","v":{"v":17.80821917808219,"d":"17.8"}},null,"(euro's)"]
[{"$nulls":3},17.8,null,14600]
[null,"RTV",{"$nulls":3},"O"]
["TR / TV",{"$f":"D13*D20","v":{"v":33.76623376623376,"d":"34"}}]
[34,"%",{"$nulls":3},"O"]
[{"$nulls":5},14600]
[{"$nulls":3},1.9,null,"(euro's)"]
[{"$nulls":3},{"$f":"14600/F23","v":{"v":1.896103896103896,"d":"1.9"}},null,"Omzet"]
[{"$nulls":3},"Omloop-",{"$nulls":3},"Vl.A"]
[{"$nulls":3},"snelheid",{"$nulls":3},"Vlottende",null,1500,1500,"Voorraden"]
[{"$nulls":3},"O / TV",null,{"$f":"H24+H26","v":7700},null,"Activa"]
[{"$nulls":5},"Totaal",null,{"$f":"J22+J25+J28","v":4700}]
["Resultatenrekening 2006",null,"Kosten","Opbrengsten",null,"Vermogen",{"$nulls":3},3000,3000,"Debiteuren"]
["Opbrengsten",null,null,14600,null,"TV",null,3000]
["Inkoopkosten",null,6200,{"$nulls":4},"Vaste"]
["Bedrijfskosten",null,5000,{"$nulls":4},"Activa",null,200,200,"Kas"]
["Afschrijving",null,800,{"$nulls":4},"VA"]
["Rente",null,400]
["Winst 2006",null,{"$f":"14600-SUM(C27:C30)","v":2200}]
["Totaal",null,14600,{"$f":"D26-D31","v":14600}]